package com.wzh.demo;

/**
 * 32q'we's'r@description:
 * @author: WZH
 * @time: 2021/7/20 16:42
 */
public class Demo {

    public static void main(String[] args) {
        System.out.println("");

        String a = "SELECT DSI.ID,DSI.DESCR,DSIP.DESCR AS PARENTDESCR,DSI.UNIT,DSI.FORMULAD,DSI.FORMULAMUNIT,DSI.TOFIXED,DSI.TOTIMES,NVL(DSI.LOWER,0) AS LOWER,NVL(DSI.UPPER,9999) AS UPPER\n" +
                "FROM DIAGNOSIS_SCORE_ITEM DSI\n" +
                "JOIN DIAGNOSIS_SCORE_ITEM DSIP\n" +
                "ON SUBSTR(DSI.PARENT, 0, 2) = DSIP.ID\n" +
                "WHERE DSI.ID > 100000 AND DSI.USE IS NOT NULL\n" +
                "ORDER BY DSI.ID";
        System.out.println(a);




    }
}
